Dataset statistics
| Number of variables | 11 |
|---|---|
| Number of observations | 746 |
| Missing cells | 0 |
| Missing cells (%) | 0.0% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 64.8 KiB |
| Average record size in memory | 89.0 B |
Variable types
| Numeric | 6 |
|---|---|
| Categorical | 4 |
| Boolean | 1 |
Obs Code has constant value "654" | Constant |
Magnitude Obs Code has constant value "654" | Constant |
Obs Code Agreement has constant value "True" | Constant |
Date has a high cardinality: 112 distinct values | High cardinality |
Bulletin has a high cardinality: 235 distinct values | High cardinality |
Residual RA is highly overall correlated with Residual Dec and 1 other fields | High correlation |
Residual Dec is highly overall correlated with Residual RA and 1 other fields | High correlation |
Diagonal Residual is highly overall correlated with Residual RA and 1 other fields | High correlation |
Bulletin is uniformly distributed | Uniform |
Unnamed: 0 has unique values | Unique |
Residual RA has 243 (32.6%) zeros | Zeros |
Residual Dec has 270 (36.2%) zeros | Zeros |
Diagonal Residual has 96 (12.9%) zeros | Zeros |
Reproduction
| Analysis started | 2022-12-16 21:34:48.243707 |
|---|---|
| Analysis finished | 2022-12-16 21:34:53.959553 |
| Duration | 5.72 seconds |
| Software version | pandas-profiling vv3.5.0 |
| Download configuration | config.json |
Unnamed: 0
Real number (ℝ)
| Distinct | 746 |
|---|---|
| Distinct (%) | 100.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3908.3874 |
| Minimum | 20 |
|---|---|
| Maximum | 7389 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.7 KiB |
Quantile statistics
| Minimum | 20 |
|---|---|
| 5-th percentile | 412.25 |
| Q1 | 2138.5 |
| median | 4189.5 |
| Q3 | 5632.25 |
| 95-th percentile | 7036.75 |
| Maximum | 7389 |
| Range | 7369 |
| Interquartile range (IQR) | 3493.75 |
Descriptive statistics
| Standard deviation | 2117.0307 |
|---|---|
| Coefficient of variation (CV) | 0.54166349 |
| Kurtosis | -1.1464872 |
| Mean | 3908.3874 |
| Median Absolute Deviation (MAD) | 1748 |
| Skewness | -0.18094796 |
| Sum | 2915657 |
| Variance | 4481819.2 |
| Monotonicity | Strictly increasing |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20 | 1 | 0.1% |
| 5272 | 1 | 0.1% |
| 5211 | 1 | 0.1% |
| 5212 | 1 | 0.1% |
| 5213 | 1 | 0.1% |
| 5230 | 1 | 0.1% |
| 5231 | 1 | 0.1% |
| 5232 | 1 | 0.1% |
| 5253 | 1 | 0.1% |
| 5254 | 1 | 0.1% |
| Other values (736) | 736 |
| Value | Count | Frequency (%) |
| 20 | 1 | |
| 25 | 1 | |
| 26 | 1 | |
| 38 | 1 | |
| 39 | 1 | |
| 40 | 1 | |
| 41 | 1 | |
| 62 | 1 | |
| 63 | 1 | |
| 64 | 1 |
| Value | Count | Frequency (%) |
| 7389 | 1 | |
| 7388 | 1 | |
| 7379 | 1 | |
| 7351 | 1 | |
| 7350 | 1 | |
| 7324 | 1 | |
| 7323 | 1 | |
| 7322 | 1 | |
| 7303 | 1 | |
| 7302 | 1 |
Date
Categorical
| Distinct | 112 |
|---|---|
| Distinct (%) | 15.0% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.7 KiB |
| 7/27/2022 | 19 |
|---|---|
| 8/30/2022 | 18 |
| 8/21/2022 | 18 |
| 6/28/2022 | 18 |
| 6/21/2022 | 18 |
| Other values (107) |
Length
| Max length | 10 |
|---|---|
| Median length | 9 |
| Mean length | 8.7453083 |
| Min length | 8 |
Characters and Unicode
| Total characters | 6524 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 2 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 3 ? |
|---|---|
| Unique (%) | 0.4% |
Sample
| 1st row | 1/7/2022 |
|---|---|
| 2nd row | 1/7/2022 |
| 3rd row | 1/7/2022 |
| 4th row | 1/13/2022 |
| 5th row | 1/13/2022 |
Common Values
| Value | Count | Frequency (%) |
| 7/27/2022 | 19 | 2.5% |
| 8/30/2022 | 18 | 2.4% |
| 8/21/2022 | 18 | 2.4% |
| 6/28/2022 | 18 | 2.4% |
| 6/21/2022 | 18 | 2.4% |
| 8/22/2022 | 17 | 2.3% |
| 6/2/2022 | 16 | 2.1% |
| 8/23/2022 | 16 | 2.1% |
| 10/20/2022 | 15 | 2.0% |
| 2/4/2022 | 14 | 1.9% |
| Other values (102) | 577 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 7/27/2022 | 19 | 2.5% |
| 8/30/2022 | 18 | 2.4% |
| 8/21/2022 | 18 | 2.4% |
| 6/28/2022 | 18 | 2.4% |
| 6/21/2022 | 18 | 2.4% |
| 8/22/2022 | 17 | 2.3% |
| 6/2/2022 | 16 | 2.1% |
| 8/23/2022 | 16 | 2.1% |
| 10/20/2022 | 15 | 2.0% |
| 2/4/2022 | 14 | 1.9% |
| Other values (102) | 577 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 2732 | |
| / | 1492 | |
| 0 | 909 | 13.9% |
| 1 | 295 | 4.5% |
| 6 | 201 | 3.1% |
| 8 | 195 | 3.0% |
| 7 | 178 | 2.7% |
| 3 | 146 | 2.2% |
| 5 | 132 | 2.0% |
| 4 | 127 | 1.9% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 5032 | |
| Other Punctuation | 1492 | 22.9% |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 2732 | |
| 0 | 909 | 18.1% |
| 1 | 295 | 5.9% |
| 6 | 201 | 4.0% |
| 8 | 195 | 3.9% |
| 7 | 178 | 3.5% |
| 3 | 146 | 2.9% |
| 5 | 132 | 2.6% |
| 4 | 127 | 2.5% |
| 9 | 117 | 2.3% |
Other Punctuation
| Value | Count | Frequency (%) |
| / | 1492 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 6524 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 2 | 2732 | |
| / | 1492 | |
| 0 | 909 | 13.9% |
| 1 | 295 | 4.5% |
| 6 | 201 | 3.1% |
| 8 | 195 | 3.0% |
| 7 | 178 | 2.7% |
| 3 | 146 | 2.2% |
| 5 | 132 | 2.0% |
| 4 | 127 | 1.9% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6524 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 2732 | |
| / | 1492 | |
| 0 | 909 | 13.9% |
| 1 | 295 | 4.5% |
| 6 | 201 | 3.1% |
| 8 | 195 | 3.0% |
| 7 | 178 | 2.7% |
| 3 | 146 | 2.2% |
| 5 | 132 | 2.0% |
| 4 | 127 | 1.9% |
| Distinct | 235 |
|---|---|
| Distinct (%) | 31.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.7 KiB |
| 2022-L78 | 8 |
|---|---|
| 2022-Q63 | 7 |
| 2022-L71 | 7 |
| 2022-L09 | 7 |
| 2022-O73 | 7 |
| Other values (230) |
Length
| Max length | 9 |
|---|---|
| Median length | 9 |
| Mean length | 9 |
| Min length | 9 |
Characters and Unicode
| Total characters | 6714 |
|---|---|
| Distinct characters | 32 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 9 ? |
|---|---|
| Unique (%) | 1.2% |
Sample
| 1st row | 2022-A62 |
|---|---|
| 2nd row | 2022-A62 |
| 3rd row | 2022-A62 |
| 4th row | 2022-A171 |
| 5th row | 2022-A171 |
Common Values
| Value | Count | Frequency (%) |
| 2022-L78 | 8 | 1.1% |
| 2022-Q63 | 7 | 0.9% |
| 2022-L71 | 7 | 0.9% |
| 2022-L09 | 7 | 0.9% |
| 2022-O73 | 7 | 0.9% |
| 2022-Q47 | 7 | 0.9% |
| 2022-M25 | 7 | 0.9% |
| 2022-S236 | 6 | 0.8% |
| 2022-M89 | 6 | 0.8% |
| 2022-Q88 | 6 | 0.8% |
| Other values (225) | 678 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 2022-l78 | 8 | 1.1% |
| 2022-l71 | 7 | 0.9% |
| 2022-l09 | 7 | 0.9% |
| 2022-o73 | 7 | 0.9% |
| 2022-q47 | 7 | 0.9% |
| 2022-m25 | 7 | 0.9% |
| 2022-q63 | 7 | 0.9% |
| 2022-q136 | 6 | 0.8% |
| 2022-m60 | 6 | 0.8% |
| 2022-q195 | 6 | 0.8% |
| Other values (225) | 678 |
Most occurring characters
| Value | Count | Frequency (%) |
| 2 | 2431 | |
| 0 | 901 | 13.4% |
| - | 746 | 11.1% |
| 516 | 7.7% | |
| 1 | 334 | 5.0% |
| 3 | 190 | 2.8% |
| 5 | 179 | 2.7% |
| 7 | 155 | 2.3% |
| 6 | 146 | 2.2% |
| 8 | 131 | 2.0% |
| Other values (22) | 985 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 4706 | |
| Dash Punctuation | 746 | 11.1% |
| Uppercase Letter | 746 | 11.1% |
| Space Separator | 516 | 7.7% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| Q | 121 | |
| M | 74 | |
| L | 73 | 9.8% |
| C | 64 | 8.6% |
| U | 48 | 6.4% |
| S | 47 | 6.3% |
| O | 37 | 5.0% |
| G | 36 | 4.8% |
| N | 33 | 4.4% |
| K | 29 | 3.9% |
| Other values (10) | 184 |
Decimal Number
| Value | Count | Frequency (%) |
| 2 | 2431 | |
| 0 | 901 | 19.1% |
| 1 | 334 | 7.1% |
| 3 | 190 | 4.0% |
| 5 | 179 | 3.8% |
| 7 | 155 | 3.3% |
| 6 | 146 | 3.1% |
| 8 | 131 | 2.8% |
| 4 | 120 | 2.5% |
| 9 | 119 | 2.5% |
Dash Punctuation
| Value | Count | Frequency (%) |
| - | 746 |
Space Separator
| Value | Count | Frequency (%) |
| 516 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 5968 | |
| Latin | 746 | 11.1% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| Q | 121 | |
| M | 74 | |
| L | 73 | 9.8% |
| C | 64 | 8.6% |
| U | 48 | 6.4% |
| S | 47 | 6.3% |
| O | 37 | 5.0% |
| G | 36 | 4.8% |
| N | 33 | 4.4% |
| K | 29 | 3.9% |
| Other values (10) | 184 |
Common
| Value | Count | Frequency (%) |
| 2 | 2431 | |
| 0 | 901 | 15.1% |
| - | 746 | 12.5% |
| 516 | 8.6% | |
| 1 | 334 | 5.6% |
| 3 | 190 | 3.2% |
| 5 | 179 | 3.0% |
| 7 | 155 | 2.6% |
| 6 | 146 | 2.4% |
| 8 | 131 | 2.2% |
| Other values (2) | 239 | 4.0% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6714 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 2 | 2431 | |
| 0 | 901 | 13.4% |
| - | 746 | 11.1% |
| 516 | 7.7% | |
| 1 | 334 | 5.0% |
| 3 | 190 | 2.8% |
| 5 | 179 | 2.7% |
| 7 | 155 | 2.3% |
| 6 | 146 | 2.2% |
| 8 | 131 | 2.0% |
| Other values (22) | 985 |
Obs Code
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.7 KiB |
| 654 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2238 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 654 |
|---|---|
| 2nd row | 654 |
| 3rd row | 654 |
| 4th row | 654 |
| 5th row | 654 |
Common Values
| Value | Count | Frequency (%) |
| 654 | 746 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 654 | 746 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 746 | |
| 5 | 746 | |
| 4 | 746 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2238 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 746 | |
| 5 | 746 | |
| 4 | 746 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2238 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 746 | |
| 5 | 746 | |
| 4 | 746 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2238 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 746 | |
| 5 | 746 | |
| 4 | 746 |
| Distinct | 13 |
|---|---|
| Distinct (%) | 1.7% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.11487936 |
| Minimum | 0 |
|---|---|
| Maximum | 1.8 |
| Zeros | 243 |
| Zeros (%) | 32.6% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.1 |
| Q3 | 0.1 |
| 95-th percentile | 0.3 |
| Maximum | 1.8 |
| Range | 1.8 |
| Interquartile range (IQR) | 0.1 |
Descriptive statistics
| Standard deviation | 0.15554554 |
|---|---|
| Coefficient of variation (CV) | 1.3539903 |
| Kurtosis | 34.248737 |
| Mean | 0.11487936 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 4.5426291 |
| Sum | 85.7 |
| Variance | 0.024194415 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=13)
| Value | Count | Frequency (%) |
| 0.1 | 338 | |
| 0 | 243 | |
| 0.2 | 89 | 11.9% |
| 0.3 | 40 | 5.4% |
| 0.4 | 13 | 1.7% |
| 0.5 | 11 | 1.5% |
| 0.7 | 4 | 0.5% |
| 1.2 | 2 | 0.3% |
| 0.6 | 2 | 0.3% |
| 1.8 | 1 | 0.1% |
| Other values (3) | 3 | 0.4% |
| Value | Count | Frequency (%) |
| 0 | 243 | |
| 0.1 | 338 | |
| 0.2 | 89 | 11.9% |
| 0.3 | 40 | 5.4% |
| 0.4 | 13 | 1.7% |
| 0.5 | 11 | 1.5% |
| 0.6 | 2 | 0.3% |
| 0.7 | 4 | 0.5% |
| 0.8 | 1 | 0.1% |
| 0.9 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 1.8 | 1 | 0.1% |
| 1.5 | 1 | 0.1% |
| 1.2 | 2 | 0.3% |
| 0.9 | 1 | 0.1% |
| 0.8 | 1 | 0.1% |
| 0.7 | 4 | 0.5% |
| 0.6 | 2 | 0.3% |
| 0.5 | 11 | 1.5% |
| 0.4 | 13 | 1.7% |
| 0.3 | 40 |
| Distinct | 9 |
|---|---|
| Distinct (%) | 1.2% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.097184987 |
| Minimum | 0 |
|---|---|
| Maximum | 1 |
| Zeros | 270 |
| Zeros (%) | 36.2% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0 |
| median | 0.1 |
| Q3 | 0.1 |
| 95-th percentile | 0.3 |
| Maximum | 1 |
| Range | 1 |
| Interquartile range (IQR) | 0.1 |
Descriptive statistics
| Standard deviation | 0.10684046 |
|---|---|
| Coefficient of variation (CV) | 1.0993515 |
| Kurtosis | 11.248024 |
| Mean | 0.097184987 |
| Median Absolute Deviation (MAD) | 0.1 |
| Skewness | 2.3206378 |
| Sum | 72.5 |
| Variance | 0.011414884 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=9)
| Value | Count | Frequency (%) |
| 0.1 | 311 | |
| 0 | 270 | |
| 0.2 | 117 | 15.7% |
| 0.3 | 33 | 4.4% |
| 0.4 | 6 | 0.8% |
| 0.5 | 4 | 0.5% |
| 0.7 | 3 | 0.4% |
| 1 | 1 | 0.1% |
| 0.6 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 0 | 270 | |
| 0.1 | 311 | |
| 0.2 | 117 | 15.7% |
| 0.3 | 33 | 4.4% |
| 0.4 | 6 | 0.8% |
| 0.5 | 4 | 0.5% |
| 0.6 | 1 | 0.1% |
| 0.7 | 3 | 0.4% |
| 1 | 1 | 0.1% |
| Value | Count | Frequency (%) |
| 1 | 1 | 0.1% |
| 0.7 | 3 | 0.4% |
| 0.6 | 1 | 0.1% |
| 0.5 | 4 | 0.5% |
| 0.4 | 6 | 0.8% |
| 0.3 | 33 | 4.4% |
| 0.2 | 117 | 15.7% |
| 0.1 | 311 | |
| 0 | 270 |
Num
Real number (ℝ)
| Distinct | 71 |
|---|---|
| Distinct (%) | 9.5% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 26.912869 |
| Minimum | 4 |
|---|---|
| Maximum | 243 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.7 KiB |
Quantile statistics
| Minimum | 4 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 17 |
| median | 21 |
| Q3 | 30 |
| 95-th percentile | 53 |
| Maximum | 243 |
| Range | 239 |
| Interquartile range (IQR) | 13 |
Descriptive statistics
| Standard deviation | 25.017077 |
|---|---|
| Coefficient of variation (CV) | 0.92955817 |
| Kurtosis | 50.752003 |
| Mean | 26.912869 |
| Median Absolute Deviation (MAD) | 6 |
| Skewness | 6.4591681 |
| Sum | 20077 |
| Variance | 625.85414 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 17 | 47 | 6.3% |
| 19 | 45 | 6.0% |
| 15 | 42 | 5.6% |
| 20 | 41 | 5.5% |
| 22 | 38 | 5.1% |
| 21 | 38 | 5.1% |
| 18 | 36 | 4.8% |
| 23 | 32 | 4.3% |
| 14 | 31 | 4.2% |
| 16 | 30 | 4.0% |
| Other values (61) | 366 |
| Value | Count | Frequency (%) |
| 4 | 1 | 0.1% |
| 8 | 2 | 0.3% |
| 9 | 8 | 1.1% |
| 10 | 9 | 1.2% |
| 11 | 17 | |
| 12 | 14 | 1.9% |
| 13 | 26 | |
| 14 | 31 | |
| 15 | 42 | |
| 16 | 30 |
| Value | Count | Frequency (%) |
| 243 | 1 | |
| 242 | 1 | |
| 241 | 1 | |
| 240 | 1 | |
| 239 | 1 | |
| 238 | 1 | |
| 224 | 1 | |
| 223 | 1 | |
| 85 | 1 | |
| 84 | 1 |
Magnitude
Real number (ℝ)
| Distinct | 47 |
|---|---|
| Distinct (%) | 6.3% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 20.111394 |
| Minimum | 15.9 |
|---|---|
| Maximum | 22.1 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.7 KiB |
Quantile statistics
| Minimum | 15.9 |
|---|---|
| 5-th percentile | 18.4 |
| Q1 | 19.7 |
| median | 20.3 |
| Q3 | 20.7 |
| 95-th percentile | 21.2 |
| Maximum | 22.1 |
| Range | 6.2 |
| Interquartile range (IQR) | 1 |
Descriptive statistics
| Standard deviation | 0.86701923 |
|---|---|
| Coefficient of variation (CV) | 0.043110847 |
| Kurtosis | 2.251246 |
| Mean | 20.111394 |
| Median Absolute Deviation (MAD) | 0.5 |
| Skewness | -1.1366495 |
| Sum | 15003.1 |
| Variance | 0.75172235 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=47)
| Value | Count | Frequency (%) |
| 20.5 | 52 | 7.0% |
| 20.6 | 48 | 6.4% |
| 20.3 | 48 | 6.4% |
| 20.9 | 47 | 6.3% |
| 20.4 | 44 | 5.9% |
| 20.2 | 41 | 5.5% |
| 20.7 | 39 | 5.2% |
| 20.1 | 34 | 4.6% |
| 19.6 | 28 | 3.8% |
| 19.7 | 26 | 3.5% |
| Other values (37) | 339 |
| Value | Count | Frequency (%) |
| 15.9 | 2 | 0.3% |
| 16.1 | 1 | 0.1% |
| 16.4 | 1 | 0.1% |
| 17.3 | 3 | 0.4% |
| 17.4 | 1 | 0.1% |
| 17.9 | 2 | 0.3% |
| 18 | 2 | 0.3% |
| 18.1 | 4 | 0.5% |
| 18.2 | 10 | |
| 18.3 | 11 |
| Value | Count | Frequency (%) |
| 22.1 | 1 | 0.1% |
| 21.9 | 2 | 0.3% |
| 21.8 | 2 | 0.3% |
| 21.7 | 1 | 0.1% |
| 21.6 | 1 | 0.1% |
| 21.5 | 7 | |
| 21.4 | 14 | |
| 21.3 | 6 | 0.8% |
| 21.2 | 17 | |
| 21.1 | 17 |
Magnitude Obs Code
Categorical
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 11.7 KiB |
| 654 |
|---|
Length
| Max length | 3 |
|---|---|
| Median length | 3 |
| Mean length | 3 |
| Min length | 3 |
Characters and Unicode
| Total characters | 2238 |
|---|---|
| Distinct characters | 3 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 654 |
|---|---|
| 2nd row | 654 |
| 3rd row | 654 |
| 4th row | 654 |
| 5th row | 654 |
Common Values
| Value | Count | Frequency (%) |
| 654 | 746 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| 654 | 746 |
Most occurring characters
| Value | Count | Frequency (%) |
| 6 | 746 | |
| 5 | 746 | |
| 4 | 746 |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 2238 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 6 | 746 | |
| 5 | 746 | |
| 4 | 746 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 2238 |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 6 | 746 | |
| 5 | 746 | |
| 4 | 746 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2238 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 6 | 746 | |
| 5 | 746 | |
| 4 | 746 |
Obs Code Agreement
Boolean
| Distinct | 1 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 6.6 KiB |
| True |
|---|
| Value | Count | Frequency (%) |
| True | 746 |
| Distinct | 29 |
|---|---|
| Distinct (%) | 3.9% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 0.17435326 |
| Minimum | 0 |
|---|---|
| Maximum | 2.059126 |
| Zeros | 96 |
| Zeros (%) | 12.9% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 11.7 KiB |
Quantile statistics
| Minimum | 0 |
|---|---|
| 5-th percentile | 0 |
| Q1 | 0.1 |
| median | 0.14142136 |
| Q3 | 0.2236068 |
| 95-th percentile | 0.41231056 |
| Maximum | 2.059126 |
| Range | 2.059126 |
| Interquartile range (IQR) | 0.1236068 |
Descriptive statistics
| Standard deviation | 0.16685927 |
|---|---|
| Coefficient of variation (CV) | 0.95701839 |
| Kurtosis | 32.670775 |
| Mean | 0.17435326 |
| Median Absolute Deviation (MAD) | 0.058578644 |
| Skewness | 4.2442023 |
| Sum | 130.06753 |
| Variance | 0.027842017 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=29)
| Value | Count | Frequency (%) |
| 0.1 | 230 | |
| 0.1414213562 | 135 | |
| 0.2236067977 | 98 | |
| 0 | 96 | |
| 0.2 | 65 | 8.7% |
| 0.316227766 | 36 | 4.8% |
| 0.3 | 21 | 2.8% |
| 0.2828427125 | 10 | 1.3% |
| 0.3605551275 | 8 | 1.1% |
| 0.4123105626 | 7 | 0.9% |
| Other values (19) | 40 | 5.4% |
| Value | Count | Frequency (%) |
| 0 | 96 | |
| 0.1 | 230 | |
| 0.1414213562 | 135 | |
| 0.2 | 65 | 8.7% |
| 0.2236067977 | 98 | |
| 0.2828427125 | 10 | 1.3% |
| 0.3 | 21 | 2.8% |
| 0.316227766 | 36 | 4.8% |
| 0.3605551275 | 8 | 1.1% |
| 0.4 | 5 | 0.7% |
| Value | Count | Frequency (%) |
| 2.059126028 | 1 | 0.1% |
| 1.513274595 | 1 | 0.1% |
| 1.236931688 | 1 | 0.1% |
| 1.204159458 | 1 | 0.1% |
| 0.9848857802 | 1 | 0.1% |
| 0.8602325267 | 2 | |
| 0.8246211251 | 1 | 0.1% |
| 0.7810249676 | 1 | 0.1% |
| 0.7280109889 | 3 | |
| 0.7211102551 | 1 | 0.1% |
Auto
The auto setting is an interpretable pairwise column metric of the following mapping:- Variable_type-Variable_type : Method, Range
- Categorical-Categorical : Cramer's V, [0,1]
- Numerical-Categorical : Cramer's V, [0,1] (using a discretized numerical column)
- Numerical-Numerical : Spearman's ρ, [-1,1]
This configuration uses the recommended metric for each pair of columns.
Spearman's ρ
The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.
Pearson's r
The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.
Kendall's τ
Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.
Phik (φk)
Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here. A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
| Unnamed: 0 | Date | Bulletin | Obs Code | Residual RA | Residual Dec | Num | Magnitude | Magnitude Obs Code | Obs Code Agreement | Diagonal Residual | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 20 | 20 | 1/7/2022 | 2022-A62 | 654 | 0.4 | 0.1 | 23 | 21.8 | 654 | True | 0.412311 |
| 25 | 25 | 1/7/2022 | 2022-A62 | 654 | 0.3 | 0.2 | 28 | 21.5 | 654 | True | 0.360555 |
| 26 | 26 | 1/7/2022 | 2022-A62 | 654 | 0.1 | 0.1 | 29 | 20.5 | 654 | True | 0.141421 |
| 38 | 38 | 1/13/2022 | 2022-A171 | 654 | 0.2 | 0.1 | 13 | 20.9 | 654 | True | 0.223607 |
| 39 | 39 | 1/13/2022 | 2022-A171 | 654 | 0.1 | 0.2 | 14 | 20.9 | 654 | True | 0.223607 |
| 40 | 40 | 1/13/2022 | 2022-A171 | 654 | 0.3 | 0.3 | 15 | 18.4 | 654 | True | 0.424264 |
| 41 | 41 | 1/13/2022 | 2022-A171 | 654 | 1.8 | 1.0 | 16 | 18.4 | 654 | True | 2.059126 |
| 62 | 62 | 1/13/2022 | 2022-A173 | 654 | 0.0 | 0.1 | 12 | 20.6 | 654 | True | 0.100000 |
| 63 | 63 | 1/13/2022 | 2022-A173 | 654 | 0.1 | 0.1 | 13 | 20.6 | 654 | True | 0.141421 |
| 64 | 64 | 1/13/2022 | 2022-A173 | 654 | 0.0 | 0.1 | 14 | 21.1 | 654 | True | 0.100000 |
| Unnamed: 0 | Date | Bulletin | Obs Code | Residual RA | Residual Dec | Num | Magnitude | Magnitude Obs Code | Obs Code Agreement | Diagonal Residual | |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 7302 | 7302 | 10/25/2022 | 2022-U250 | 654 | 0.0 | 0.0 | 16 | 21.0 | 654 | True | 0.000000 |
| 7303 | 7303 | 10/25/2022 | 2022-U250 | 654 | 0.1 | 0.0 | 17 | 21.0 | 654 | True | 0.100000 |
| 7322 | 7322 | 10/26/2022 | 2022-U280 | 654 | 0.0 | 0.1 | 19 | 19.5 | 654 | True | 0.100000 |
| 7323 | 7323 | 10/26/2022 | 2022-U280 | 654 | 0.0 | 0.1 | 20 | 19.5 | 654 | True | 0.100000 |
| 7324 | 7324 | 10/26/2022 | 2022-U280 | 654 | 0.0 | 0.2 | 21 | 19.5 | 654 | True | 0.200000 |
| 7350 | 7350 | 10/27/2022 | 2022-U290 | 654 | 0.0 | 0.1 | 17 | 20.7 | 654 | True | 0.100000 |
| 7351 | 7351 | 10/27/2022 | 2022-U290 | 654 | 0.1 | 0.1 | 18 | 20.7 | 654 | True | 0.141421 |
| 7379 | 7379 | 10/29/2022 | 2022-U348 | 654 | 0.1 | 0.1 | 26 | 20.7 | 654 | True | 0.141421 |
| 7388 | 7388 | 10/29/2022 | 2022-U348 | 654 | 0.0 | 0.1 | 36 | 20.3 | 654 | True | 0.100000 |
| 7389 | 7389 | 10/29/2022 | 2022-U348 | 654 | 0.1 | 0.2 | 37 | 20.9 | 654 | True | 0.223607 |